Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
ReportingPeriodID (FK)(PK) | The unique system assigned identifier for a particular ReportingPeriod. | ID_PRD_RP | Identity | integer | ReportingPeriod(CA_PRD_RP) |
MerchandiseHierarchyGroupID (FK)(PK) | Unique system assigned identifier for a group or class of merchandise. | ID_MRHRC_GP | Identity | integer | MerchandiseHierarchyGroup(CO_MRHRC_GP) |
RevenueCostCenterID (FK)(PK) | A unique retailer assigned identifier for an accounting budget, that owns merchandise and is used to track the financial performance of the retail enterprise. | ID_CTR_RVN_CST | Identity | integer | RevenueCostCenter(CO_CTR_RVN_CST) |
BudgetSalesAmount | The total monetary value of sales, including returns which is budgeted for the MerchandisingRevenueCenter during the ReportingPeriod. | TP_SLS_NT_SLS_BDG | Money | decimal(16,5) | |
ActualSalesAmount | The total monetary value of sales, including returns which were made by the MerchandisingRevenueCenter during the ReportingPeriod. | TP_SLS_ACT | Money | decimal(16,5) | |